Sums:
Only points that contain an x and a y component are considered in calculations. This allows for gaps in the data to be processed properly. This means that sums for columns are only  done for points with both an x and a y value. Furthermore,  I haven't given the weighted sums as these generally confuse people when the sum looks very wrong (which for a weighted sum it is not!).